<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>Make Me Elvis - Send Email</title>
  <link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
  <img src="blankface.jpg" width="161" height="350" alt="" style="float:right" />
  <img name="elvislogo" src="elvislogo.gif" width="229" height="32" border="0" alt="Make Me Elvis" />
  <p><strong>Private:</strong> For Elmer's use ONLY<br />
  Write and send an email to mailing list members.</p>
<?php
  if(isset($_POST['Submit'])){
    $from = 'Snowitty@163.com';
    $subject = $_POST['subject'];
    $text  = $_POST['elvismail'];
    $out_form = false;
    
    if(empty($subject) && empty($text)){
        echo 'You forgot the email subject and body text.<br />';
        $out_form = true;
    }
    if(empty($subject) && (!empty($text))){
        echo 'You forgot the email subject.<br />';
        $out_form = true;
    }
    if((!empty($subject)) && empty($text)){
        echo 'You forgot the email body text.<br />';
        $out_form = true;
    }   
  }else{
    $out_form = true;
  }
  if((!empty($subject)) && (!empty($text))){
    $dbc = mysqli_connect('localhost', 'root', '', 'elvis_store');
    $query = "SELECT * FROM email_list";
    $result = mysqli_query($dbc, $query);
    
    while($row = mysqli_fetch_array($result)){
        $to = $row['email'];
        $first_name = $row['first_name'];
        $last_name  = $row['last_name'];
        $msg = "Dear $first_name $last_name,\n$text";
        @mail($to, $subject, $msg,'From:'.$row);
        echo "Email send to: $to.<br/>";
    }
    mysqli_close($dbc);
  }
  if($out_form){
?>
  <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
    <label for="subject">Subject of email:</label><br />
    <input id="subject" name="subject" type="text" size="30" value="<?php echo @$subject; ?>"/><br />
    <label for="elvismail">Body of email:</label><br />
    <textarea id="elvismail" name="elvismail" rows="8" cols="40"><?php echo @$text; ?></textarea><br />
    <input type="submit" name="Submit" value="Submit" />
  </form>
<?php
}
?>
</body>
</html>
